Included with this assignment is an Excel spreadsheet that contains data with two dimension values. The purpose of this assignment is to demonstrate steps performed in a K-Means Cluster analysis. Review the k-MEANS CLUSTERING ALGORITHM section in Chapter 4 of the et. . textbook for additional background. Use Excel to perform the following data analysis. You will use Excel to help with calculations, but only standard functions should be used (i.e. dont use a plug-in to perform the analysis for you.) You need to show your work doing this analysis the long way. If you were to repeat steps 4 through 6, what will likely happen with the cluster centroids? The rubric for this assignment can be viewed when clicking on the assignment link.
